DISCONTINUED: not enough of my contacts use XMPP

Setup

Tested for Ubuntu 14.04

Prerequisites: MySQL Server installed

• Add prosody repo (for latest release)

    echo "deb http://packages.prosody.im/debian $(lsb_release -sc) main" | sudo tee -a /etc/apt/sources.list.d/packages.prosody.im.list
    wget http://prosody.im/files/prosody-debian-packages.key
    apt-key add prosody-debian-packages.key
    apt-get update

• Install Prosody and dependencies

    apt-get install prosody lua-dbi-mysql lua-zlib

• Install Auth Module

    cd /usr/lib/prosody/modules
    wget http://prosody-modules.googlecode.com/hg/mod_auth_sql/mod_auth_sql.lua

• Prepare Database mysql -u root -p

    CREATE DATABASE prosody;
    GRANT ALL ON prosody.* TO prosody@'localhost' IDENTIFIED BY 'prosodySecret';
    CREATE TABLE authreg ( username VARCHAR(200), realm VARCHAR(200), password VARCHAR(200) );
    INSERT INTO authreg VALUES ( 'me', 'mydomain.tld', 'myPassWord');

• Prosody Configuration nano /etc/prosody/prosody.cfg.lua

• Restart and Add User service prosody restart

References

• https://prosody.im/